﻿CREATE TABLE [dbo].[EBRClaim]
(
[PatientName] [nvarchar] (255) NULL,
[FromServiceDate] [nvarchar] (255) NULL,
[ToServiceDate] [nvarchar] (255) NULL,
[PatientControlNumber] [nvarchar] (255) NULL,
[TotalClaimCharge] [nvarchar] (255) NULL,
[BillingProviderTaxID] [nvarchar] (255) NULL,
[ClearingHouseTraceNumber] [nvarchar] (255) NULL,
[PayerClaimNumber] [nvarchar] (255) NULL,
[AvailityTraceNumber] [nvarchar] (255) NULL,
[Claim_3_Child10] [nvarchar] (255) NULL,
[Claim_3_Child11] [nvarchar] (255) NULL,
[HeaderID] [int] NULL,
[AvailityBatchID] [nvarchar] (255) NULL,
[FileControlNumber] [nvarchar] (255) NULL
) ON [PRIMARY]


GO
EXEC sp_addextendedproperty N'Purpose', N'This is an Electronic Batch Report from Availity', 'SCHEMA', N'dbo', 'TABLE', N'EBRClaim', NULL, NULL

